Turnover by Year
14


Go to Custom objects and drag Combo chart to the sheet. Resize the object then change the title to ‘Turnover by Year’.Click add dimension and select YearMonthDD. Click on Add measure and Paste the expression below. (FABS(Count(EmpID)- (Count( {<EmploymentStatus ={'Terminated for Cause','Voluntarily Terminated'} >}Total EmploymentStatus )))) / Count(Total EmpID)Change the label to Active%.Change the formatting to number formatting and select the percentage with no decimal values. Make the color gray or #7b7a78 and make the opacity 75%.Add a second measure and select Turnover%. Unlink the measure and change Count(EmploymentStatus) to (Count(Total EmploymentStatus)))Change the formatting to number formatting and select the percentage with no decimal values.Select Bar for the representation. The bar color should be black. Go to presentation under Appearance and overlap for the bar type. Add a new measure and select NPS. The axis position is secondary and select symbol for representation. Pick star as a representation and make the color ='#b73d2d'.Change the formatting to number formatting and select the number with no decimal values.Add the last measure and select Months worked. Change the formatting to number formatting and select the number with no decimal values.The axis position is secondary and select line for representation. The line style should be solid and the curve style should be linear.Show the data point and the type should be area. The color for the area should be #914980.Go to sorting and sort it by YearMonthDD.Click on X-axis (bottom) under appearance and unselect Dimension title.
Click on Y-axis (left) under appearance and unselect Dimension title. Choose black for the font and line color.Then click on Y-axis(right) under appearance and unselect Dimension title. Select purple (#914980) for the font and axis line color. The font size should be 12.
12 Reasons Employees Leave Organizations